[dbo].[WorkflowDemoLog]

SQLServer > iMIS1521GA > Tables > dbo.WorkflowDemoLog

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Created	10:31:43 AM Tuesday, March 02, 2010
Last Modified	11:40:10 AM Monday, February 20, 2012

Columns

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_WorkflowDemoLog: LoginUser\LogTimeStamp$	LoginUser	nvarchar(50)	100
$Cluster Primary Key PK_WorkflowDemoLog: LoginUser\LogTimeStamp$	LogTimeStamp	datetime	8	(getdate())
	Message	nvarchar(100)	200
	MarkedForDeleteOn	datetime	8

Indexes

	Name	Columns	Unique
$Cluster Primary Key PK_WorkflowDemoLog: LoginUser\LogTimeStamp$	PK_WorkflowDemoLog	LoginUser, LogTimeStamp

SQL Script

CREATE TABLE [dbo].[WorkflowDemoLog]
(
[LoginUser] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LogTimeStamp] [datetime] NOT NULL CONSTRAINT [DF_WorkflowDemoLog_LogTimeStamp] DEFAULT (getdate()),
[Message] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkflowDemoLog] ADD CONSTRAINT [PK_WorkflowDemoLog] PRIMARY KEY CLUSTERED ([LoginUser], [LogTimeStamp]) ON [PRIMARY]
GO

Uses